package com.isec.base.monit.dao;

import org.springframework.stereotype.Service;

import com.core.security.database.jdbc.BaseDao;
import com.isec.base.monit.dto.SourceDto;

@Service
public class SourceDao extends BaseDao<SourceDto, String>{

	public SourceDto getLastPmData() {
			
		return this.getObject("SELECT * FROM (SELECT A.*,B.DATAINDEX FROM IDGAR_PM_TAB A,IGDAR_DATALOG_TAB B WHERE A.PM_ID = B.DATAID AND B.DATATYPE = '2') T ORDER BY T.DATAINDEX DESC LIMIT 1");
	}

}
